log using table_A3, replace

***************** Replication of Franchino, Fabio, and Camilla Mariotto. “Bargaining Outcomes and Success in EU Economic Governance Reforms”. Political Science Research and Methods.

version 16
* pause on

*******************   TABLE A3 OF DESCRIPTIVE STATISTICS OF COUNTRY POSITIONS
***** country positions in Table A3
use PROCmodel_data.dta, replace
* drop countries without voting right
drop if vot_right==1
gen cntry_pos_sd = cntry_pos
gen N = cntry_pos
collapse (mean) cntry_pos (sd) cntry_pos_sd (count) N, by(country)
sort cntry_pos
format %5.0g cntry_pos
format %6.0g cntry_pos_sd
* The data are the means, standard deviations and N of the country positions in Table A3

***** european commission and parliament positions, and outcome in Table A3
use PROCmodel_data.dta, replace
* drop countries without voting right
drop if vot_right==1
collapse comm ep_1 outcome , by(issue_id)
gen N = issue_id
gen ep_1_sd = ep_1
gen comm_sd = comm
gen outcome_sd = outcome

collapse (mean) comm ep_1 outcome (sd) comm_sd ep_1_sd outcome_sd (count) N
format %5.0g comm ep_1 outcome
format %6.0g comm_sd ep_1_sd outcome_sd

order comm comm_sd ep_1 ep_1_sd outcome outcome_sd
* The data are the means, standard deviations and N of the Commission, Parliament positions and the outcomes in Table A3

log close